package com.jstide.credit.data.service.biz;

import cn.hutool.db.Entity;
import com.jstide.credit.data.service.Algorithm;
import lombok.Getter;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.util.List;

public class Factor33 extends Algorithm {

    private static final Logger logger = LoggerFactory.getLogger(Factor33.class);

    @Getter
    public final  String name="33";

    //志愿者信息
    //存在即给分，取值3年内
    //50
    @Getter
    public  final String sql = "  select count(1) as TOTAL from ZRRZYZXX where join_id=@joinId  and   DJRQ  > trunc(sysdate)-(INTERVAL '3' YEAR)   ";


    @Getter
    public final int defaultScore=50;

    @Override
    public int translate(String rs) {
        return 0;
    }

    @Override
    public int translate(List<Entity> rs) {
        return FactorHelper.translateTotal(name,defaultScore,rs);
    }


}
